x Want to participate? Join the group to interact
  • State Verified Answer
  • Replies 2 replies
  • Subscribers 136 subscribers
  • Views 168 views
  • Users 0 members are here
Browse Forums
Announcements
237
topics
29
replies
General Discussion
5k
topics
13k
replies
Sage Data & Analytics
56
topics
95
replies
Sage Enterprise Intelligence
210
topics
416
replies
Sage Intelligence Reporting
121
topics
322
replies
Stephen

Import of miscellaneous receipts for inventory

SOLVED
Posted By

We are importing inventory receipts into a new warehouse.    We are using the import template FTIMSR.  It works fine.   The issue we are having is dealing with errors and the subsequent creation of multiple misc receipt records in Sage X3.   

If we build a long list of inventory items to import it's invariable going to encounter an error on ONE item and reject the entire submission until the next header or "E" record.

If we break it up into smaller more managable number of records we get a miscellaneous receipt record for every header or "E" record.

It works, it's just messy.

Is there a trick?   Perhaps modifying the header or "E" record to specify a previously created Miscellaneous Receipt (VCRNUM as a constant) so that it will add to that receipt?   

Thanks.

. 

Top Replies

  • +1 verified

    Hi  

    I understand you don't want to create large misc. receipt nor single line misc. receipt when importing the stock.

    Would it be possible to create different flat files with maximum 100 lines…

  • +1
    verified answer

    Hi  

    I understand you don't want to create large misc. receipt nor single line misc. receipt when importing the stock.

    Would it be possible to create different flat files with maximum 100 lines (as an example) ? So each document created would be smaller with higher chance of success without managing an individual misc. recept for each line imported.

  • 0 in reply to Julien Patureau

    We did that to an extent but there were still too many errors.   We literally created an E record for every entry and this let us instantly isolate all the errors.   We also created 3122 miscellaneous receipts at the largest  location.  That's a lot but it seems to have worked.   We have not tied out the numbers yet.  Still have a location to do and they didn't have all the bins defined that they told us to put the items in.  

*Community Hub is the new name for Sage City