Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Importing journal entr...
Small and medium business | Business Central, N...
Suggested answer

Importing journal entries and applying to a customer

(1) ShareShare
ReportReport
Posted on by CB-25091721-0 29
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
 
 
 
 
  • Mustafa Omerbegović Profile Picture
    Mustafa Omerbegović 1,238 Super User 2025 Season 1 on at
    Importing journal entries and applying to a customer
    Hello again,
     
    After reading Yun's reply I realized I misunderstood that you don't want to post payments.
     
    So, in that case, you can enter space into the Document Type field, 
     
    For the Bal. Account Type field you can choose GL Account and for the Bal. Account No. you can choose the desired GL account no. 
     
    Two GL entries and one customer ledger entry (with blank document type) will be created, but no invoice will be created.
    Since it is a loan, you will need to apply that someday, so a customer ledger entry shouldn't be a problem.
    In this case, in your configuration package your account ID is the receivables account defined on the customer posting group assigned to the selected customer, and the customer ID is the system ID from the customer table.
     
    Greetings
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 77,351 Super User 2025 Season 1 on at
    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ć Profile Picture
    Mustafa Omerbegović 1,238 Super User 2025 Season 1 on at
    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Congratulations to the January Top 10 leaders!

Check out the January community rock stars...

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,234 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,994 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans