How to make Customer Freight account visible to Invoicing

  • 13 January 2024
  • 3 replies

A lot of our Customers want us to ship product Collect and bill their freight account.  We are not integrating Carriers into our system as of yet but has anyone come up with a good way for Order Entry to key in the Customer’s freight account so it is visible on the Shipment Conformation and the Invoicing department will charge the correct account. 

all ideas are welcome.  


Best answer by bryanb39 14 January 2024, 18:02

View original

3 replies

Userlevel 6
Badge +4

Why not use shipping terms?

Userlevel 6
Badge +5

We created a Ship Via for this and then our shipping department knew to bill the customer account in Shipstation for example.   

One thing to improve this would be to add a Customer Attribute for their account number and then call that to print on the shipping confirmation if that works for your flow.  In our case we already have a shipping notes custom field.  

To add that to the shipping confirmation report, you’d want to add the CSAnswers table to the schema, the relationship would be Noteid of the Customer and RefNoteID on CSAnswers, then create a hidden parameter with a default value of CUSSHIPACT (or what ever it is) so you can also add CUSTSHIP = ATTRIBUTEID in the relationship.  Be sure to use a left join.  

Thanks for the input.  We do a lot of exporting and have detailed instructions and have not found a good place for this information. i like the idea of the Attribute


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved