web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Business Central forum / Import Sales Journal v...
Business Central forum

Import Sales Journal via config package

(0) ShareShare
ReportReport
Posted on by mjarvie 10

HI,

I am importing an invoice journal in BC using a config package and have encountered a few problems:

We are importing to the customer ledger using a configuration package. this posts to general journal line (81)

 

When posting, it fails if the invoice has more than one line.

 

For example, in the attached, it fails on document number 6 as this is repeated on more than one line. Is there a way to get round this?

 

Also, when posting to the customer ledger, if there are multiple lines on the import that are the same invoice, can it post as a consolidated value on the Customer ledger?

 

Any guidance appreciated.

Categories:
Financial Management
  • Suggested answer
    Teddy Herryanto (That NAV Guy) Profile Picture
    Teddy Herryanto (Th... 14,306 Super User 2026 Season 1 on at

    You need to have one document number per lines if you are posting from sales journal.

    It sounds like Sales Invoice is more appropriate for your case.

  • Community Member Profile Picture
    Community Member on at

    Hi Teddy,

    I also used Sales Journal import (configuration package) for several Open Balance Sales invoices.  These are just one total amount per invoice.

    I got it into table 81 as SALES (template) and successfully imported into the Sales Journal.

    However, what seems strange is that the debits/credits are reversed.

    For invoices, I had debit to the Customer account and credit to the G/L Balance account (which ties back to the Opening Balance Journal).

    The imported Sales Journal had debit to the G/L Balance account and credit to Customer account.

    This is strange.  Have you encountered this issue?

    Thanks

    Peter

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard > Business Central

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans