Skip to main content
Question

Is there a way to create a GL transaction based on sales order totals?

  • March 10, 2026
  • 0 replies
  • 11 views

Forum|alt.badge.img

Hi everyone,

Our business operates with four different branches. Our website allows single-cart checkout, meaning a customer can place an order containing items from multiple branches but only complete one payment at checkout.

That payment comes through as a single prepayment, which is posted to our Unearned Revenue account.

On the backend, our system then creates the appropriate sales orders for each branch (one sales order per branch). The single prepayment is applied across all of those individual sales orders.

Our question is:
Is there a way to associate multiple AR accounts with a single prepayment based on the branch of the sales orders tied to that prepayment?

Ideally, we would like the portion of the payment applied to each sales order to post to the AR account associated with that branch, rather than everything flowing through a single AR account.

Has anyone implemented something like this or found a workaround?

Thanks in advance!

P.S. we process thousands of sales orders so anything manual is not a possibility :)