Skip to main content
Answer

How to make Customer Freight account visible to Invoicing

  • January 13, 2024
  • 3 replies
  • 124 views

Forum|alt.badge.img

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

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.  

3 replies

Jeff96
Captain II
Forum|alt.badge.img+4
  • Captain II
  • January 14, 2024

Why not use shipping terms?


bryanb39
Pro II
Forum|alt.badge.img+6
  • Pro II
  • Answer
  • January 14, 2024

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.  


Forum|alt.badge.img
  • Author
  • Jr Varsity II
  • January 14, 2024

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