News and Announcements icon

Dynamics 365 CommunityForums Business Central forum Importing journal entr...

Business Central forum

Suggested answer

Importing journal entries and applying to a customer

(1) Share

Report

Report

Posted on by CB-25091721-0

16

Hello,

i have a configuration package set up to import journal entries from another software after manipulating it in SharePoint.

The customers have loans so I don’t want to create invoices and apply payments to them.

Which field do i have to add to the config package to apply the line to their accounts when using AR or finance receivable GL account on that line.

Is it Account Id? Customer Id?

Any help appreciated

Thanks,

Cedric

All responses Img

All responses (2)

Answers Img

Answers (0)

Suggested answer

YUN ZHU 71,153 Super User 2024 Season 2 on at

Like (0)

Report

Importing journal entries and applying to a customer

If the Account Type is Customer, Customer Ledger Entries will be automatically created. Since you are not going to create an Invoice, it will remain in the system and cannot be applied, so I vote for Account Id.
I hope other experts can give you better suggestions.

Hope this helps.

Thanks.

ZHU
Suggested answer

Mustafa Omerbegović 991 on at

Like (0)

Report

Importing journal entries and applying to a customer

Hello,

you should use document type: payment, account type: customer (need to have assigned customer posting group), and account no. (it's a customer no.). Also, make sure that other mandatory data is provided within the configuration package.
The result is two GL entries, one assigned receivables account on the customer's posting group, and the other is balance acc. no. (usually bank ACC.) one customer ledger entry and one bank acc ledger entry if you used bank acc as bal. acc. in the journal line.

Greetings

Helpful resources

News and Announcements

Forum Structure Changes Coming Soon!

Quick Links

Leaderboard

#1

André Arnaud de Cal... 290,734 Super User 2024 Season 2

#2

Martin Dráb 229,021 Most Valuable Professional

#3

nmaenpaa 101,150

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans