Skip to main content

Hello everyone

 

I am struggling with my  export scenario that I created to export shipment records (detailed records) since I want the PO numbre , product code and shipped qty. 

 

However, after preparing the export, I have the same product codes (same lines) of the first shipment on all of the shipement records. (same 3 products are repeated everywhere)

 

  

There is something wrong with my scenario but I  can’t find it. Please HELP 

 

Hello Nawres,

For the Reference Nbr row in the mapping mentioned, you need to set =Every, which makes the scenario export all records available in Acumatica ERP. The way you set it up now (N Ref), the scenario only exports the first row.

For more info, refer to the I100 Integration Scenarios training course.

 


Hello @irina

 

Thank you for your answer But i did  try Reference Nbr=Every and it will show the fist shipement record only 


Initial rows of your mapping should look like this (an example of AR Invoices export is taken). Please check:

 


Hello 

 

For the shipment record I don’t have the same Keys:  only the ShipmentNbr as a key  

 

When preparing this scenario: I only have the 3 lines of the first shpment record

 


Looks like the OrderType, OrderNbr keys should be specified. Please check:

I’ve tested this scenario, it works like a charm. The only thing is that by design the Shipping and Billing addresses are only exported for one detail line.


I’m attaching a working scenario to export shipments with their detail lines. The Commit check box is actually needed for =Every clause.


@Irina Thank you 

 

And If I want to export the article, its description (TranDesc) and Shipped Qty; There is no needed key  to link them to the  POnbr? 

 


No, you just need to select the correct fields and map them to the corresponding Excel columns.

I forgot to exclude condition on the sample scenario, and re-uploaded the correct one on the initial comment.


@Irina 

 

It works !!! 😃 😃 :D 

Thank U soooooooooooo much;  you saved my day :) 


Reply