Importing Purchase Journals

Question

I'm attempting to import a purchase journal, I've included the mandatory fields listed at What are the Purchase Journal fields for Import / Export? 
 So these are the ones I have included: 
 Vendor ID,Date,Date Due,Accounts Payable Account,Number of Distributions,G/L Account,Quantity,Item ID,U/M ID,U/M No. of Stocking Units,Description,Unit Price,Amount,Recur Number,Recur Frequency 
 I had originally included this field as well: Invoice/CM # 
 
 However it kept getting stuck so I removed it from it completely in order to figure out what's wrong. It keeps asking for it even though I've removed it from the chosen fields when importing and it's not included in the .csv . It keeps getting stuck and stuck and now I can't even figure out what's wrong with it because it has no reason to keep getting stuck there.

Any help would be appreciated.

John Parr · Answer

It has every reason to get stuck there. 
 I can't see the values in the "Number of distributions" column, but for the sake of argument, I'll assume it's 1 all the way down. 
 You haven't included the column for "Invoice/CM distribution." Without the additional logic of that field AND the Invoice/CM # field, the import doesn't know where one invoice ends and the next begins. I haven't expressly tested it, but that would be my educated guess--that you can get by without the Invoice/CM# OR the Invoice/CM distribution, but you can't do without both. In the absence of both, the import doesn't know which transaction is which.

Best Business Strategies · Answer

So with each invoice there are usually several lines per transaction. So if you sell 3 items and you have sales tax, that would be 4 transaction lines. The number of distributions would be 4. It tells Sage 50 to go the next transaction when the 4 lines have been imported. 
 Number of distributions is not the total lines being imported.

Sage 50 US

Importing Purchase Journals

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING