Is there a way to have an invoice have GL impact d...
# general
r
Is there a way to have an invoice have GL impact date on a per line item basis instead of based off the transaction record date?
a
As far as I know, it'd be safer if you script to have journal entries to be auto-created to achieve the overall GL you'd like to have eg. you have an invoice on 1/1/2021 with GL like this: DR: 12000 A/R $4000 CR: 41000 Sales Income $1000 (for line#1) CR: 41000 Sales Income $3000 (for line#2) say if you'd like line#2 to be booked on 2/1/2021 instead of 1/1/2021, then you should have your script to auto generate below 2 journal entries: • JE#1- to remove line#2's GL from 1/1/2021's GL ◦ DR: 41000 Sales Income $3000 ◦ CR: 12000 A/R $3000 • JE#2 - to make line#2's GL for 2/1/2021 ◦ DR: 12000 A/R $3000 ◦ CR: 41000 Sales Income $3000 Can also link those JEs to the original invoice. I've done something like that in case you need to use a helper for this task 🙂 - feel free to DM me