1,608
We are in the process of designing a demo site for Business Central, and have been working with both Purchase Journals and Purchase Invoices. With purchase invoices we can create multiple GL distributions for a single invoice.
Is that also possible with the purchase journal? I only see where we can enter a single GL account. Please advise.
Thank you.
JG
Thanks Dirk,
This did the trick. Appreciate the feedback.
Appreciate the feedback once again. I just realized the account type is on my export, but on the screen it is not available. The only selection available is the vendor code. Is there a setup or option that would turn on the account type field?
JG
try it with 4 lines, like:
Account_Type: G/L Account, Account_No: 6124, Amount = 88, Bal. Account No. = blank
Account_Type: G/L Account, Account_No: 6280, Amount = 23, Bal. Account No. = blank
Account_Type: G/L Account, Account_No: 6137, Amount = 10, Bal. Account No. = blank
Account_Type: Vendor, Account_No: AAM00, Amount = - 111, Bal. Account No. = blank
Posting Date, Document No., is the same in all lines
External Doc.No. is only needed in the "vendor line"
you can also use a different sorting of the lines
Appreciate the responses, however not sure if I am following correctly. Using the purchase journal screen in Business Central, I would like to create a single payable entry with multiple GL distrubutions. In attempting this I've entered three lines, each with the same Document No, same External Document No, and same vendor id (account no). The Balance Account No. and Document Amount then reflect the different distributions. The entry generates an error when previewing due to the duplicate Document No.
Are the duplicate line items possible with this screen? Please advise. Thank you.
| Posting_Date | Document_Date | Document_Type | Document_No | Incoming_Document_Entry_No | External_Document_No | Account_Type | Account_No | Description | Salespers_Purch_Code | Campaign_No | Currency_Code | Gen_Posting_Type | Gen_Bus_Posting_Group | Gen_Prod_Posting_Group | VAT_Bus_Posting_Group | VAT_Prod_Posting_Group | Amount | Amount_LCY | Debit_Amount | Credit_Amount | Tax_Liable | Tax_Area_Code | Tax_Group_Code | Use_Tax | VAT_Amount | VAT_Difference | Bal_VAT_Amount | Bal_VAT_Difference | Bal_Account_Type | Bal_Account_No |
| 2019-11-22 | 2019-11-22 | Invoice | 103 | 0 | ABC979HP | Vendor | AAM00 | Association for Accounting Marketing | -88 | -88 | 0 | 88 | False | False | 0 | 0 | 0 | 0 | G/L Account | 6124 | ||||||||||
| 2019-11-22 | 2019-11-22 | Invoice | 103 | 0 | ABC979HP | Vendor | AAM00 | Association for Accounting Marketing | -23 | -23 | 0 | 23 | False | False | 0 | 0 | 0 | 0 | G/L Account | 6280 | ||||||||||
| 2019-11-22 | 2019-11-22 | Invoice | 103 | 0 | ABC979HP | Vendor | AAM00 | Association for Accounting Marketing | -10 | -10 | 0 | 10 | False | False | 0 | 0 | 0 | 0 | G/L Account | 6137 |
Yes, it is possible … as Stefano mentioned already.
Just leave the Bal. Account blank in the first line (in all lines), move to the second line (ensure the Doc. Type and Doc. No. is the same) and enter the next account (and amount) as usual.
The last line holds the vendor account and the invoice amount / payables amount.
If you want to distribute costs to different periods … have a look at the "Deferrals" functionality
Purchase Journal permit to create different lines and on a line there's one G/L account.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (