Sage 100

I'm trying to import freight into an invoice header that was created in shipping data entry but it's telling me I can't create invoices in the batch as it was created in Shipping D/E. I'm not trying to create the invoice - I only want to add the freight. My file has the batch and invoice number in it. What's the secret to importing into invoices that were created through Shipping Data Entry???

Do you have the Shipper ID in there? I've imported new records into Shipping Data Entry before, but never tried to update existing. That is the only thing I can think of.

I don't in the file but I tried file assigning it to no avail.

I am assuming you are importing into SO invoice header. Is there a shipping data entry table that you could use instead?

It looks like the routine is trying to create a new invoice, not update an existing shipment. You should be able to update an existing shipment.

Wouldn't that be through the invoice header table? I don's see any other ""shipping"" table that I can import into (besides the Invoice Tracking table but that's another story). If I'm missing something, please let me know!

I don't know if you can import into it, the Key field for that is the invoice number...which isn't created until it batches out, right? So maybe export all the data, wipe the table and reimport the way you want it?

You could have an issue with your batch header. Can you enter the freight into the SO Invoice manually? If so, the error is indicating that you are creating new record, rather than modifying an existing record. Like @MichelleNichols suggests, check your key.

Could it be an issue with the GL_CompanyActiveBatch file?

I did a quick test where I created a batch in Shipping Data Entry, exported the Invoice No and batch into a CSV file, created a new V/I job, and selected the Invoice No and Batch no fields while assigning 50.00 to the freight amount. It worked successfully. At first I got a couple of errors though not yours but after I added the Batch No, it went through. Hope this helps.

Will try it again tomorrow. Thanks all!

If it still does not work, try changing the Batch Sub Type from ""S"" to ""I"" in GL_CompanyActiveBatch. VI will then see it as an Invoice batch as opposed to a Shipping Batch. Make sure to change it back after your import.

Did you resolve this @ThereseLogeais ? I am running into the same issue now with NEW data... even though I have a shipper ID and the fields I can find related assigned, it is still getting imported to SO Invoice Data Entry. I think for the purpose of this import it will be ok; but if you made headway I don't have to go through the process of explaining that they are both exactly the same and convincing the client to change processes.

Yes, I was testing in ABC where Retain Deleted Invoices was on. Once I cleared out the shipping batches, I simplified the import and brought in the batch, invoice number (shipping number), freight, ship via and weight and we were good!

Ok, I will give that a shot and review my import. Thanks!!