Skip to main content

Notifications

Small and medium business | Business Central, N...
Suggested answer

Can't generate General Ledger Entries

Posted on by 28
Hi Guys,
 
When posting a Warehouse Shipment transaction, it should automatically generate a journal in G/L Entries, but in the last 2 months, there are those who can generate GL Entries and there are many transactions that cannot generate journals in GL Entries.
 
For Example :  Posted sales Shipment number : SDO-MKI/09/24/0139 (can't generate GL entry)
 
 
for other number :  SDO-MKI/09/24/0138 (can generate GL Entry)
 
 
For both transactions using the same product with item code: 121-302-0071
 
 
 
Thank you for your best support
 
Best Regards
Sungkono
 
Categories:
  • SS-24070826-0 Profile Picture
    SS-24070826-0 28 on at
    Can't generate General Ledger Entries
    Hello Guys
     
    Please find a solution for this case so that the cost accounting team does not need to make a journal manually.
     
    Thank's
  • Suggested answer
    SS-24070826-0 Profile Picture
    SS-24070826-0 28 on at
    Can't generate General Ledger Entries
    Dear Jun Wang
     
    In WHS Shipment transactions, there is only Post shipment
     
    and then create "Sales Invoice" to generate AR
     
     
    Thank you
  • SS-24070826-0 Profile Picture
    SS-24070826-0 28 on at
    Can't generate General Ledger Entries
    Hi Guys
     
    I don't have any customization in this process.
    there are still many transactions last month for these products that have not yet formed a G/L Entry, for a ratio of 60:40
     
    Thank you
     
  • gdrenteria Profile Picture
    gdrenteria 12,167 Most Valuable Professional on at
    Can't generate General Ledger Entries
    Hi
    Do you have any processes that are configured by job queue and run daily related to costing post?
    Best
    GR
  • SS-24070826-0 Profile Picture
    SS-24070826-0 28 on at
    Can't generate General Ledger Entries
    Dear Guys
     
    No one should change the parameters in the "Inventory Setup" menu.
     
    currently I check that G/L Entry has appeared but yesterday did not appear
     
  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 24,785 Super User 2024 Season 2 on at
    Can't generate General Ledger Entries
    If user only post shipment, BC doesn't create GL entries.
    This is not correct. If in the Inventory Setup you have Expected Cost Posting set to yes, which we do in this case, then the system creates G/L Entries when a shipment is posted. 
     
    Some reasons G/L Entries would not be created:
    • expected cost posting in the inventory set up is turned to no. Its unlikely, but is it possible someone is changing this setting prior to posting?
    • the item cost/price is 0, which in this case its not as your item has a standard cost with a non zero cost. 
    • you have some sort of customization. The fact that two shipments on the same date, for the same item, have different results makes me think this is the case. If you go the Value Entries Page, what do you see in the Cost Posted to G/L field for both shipments?
     
  • Suggested answer
    Jun Wang Profile Picture
    Jun Wang 7,443 Super User 2024 Season 2 on at
    Can't generate General Ledger Entries
    when posting, user has options to post Shipment, Invoice, Ship and Invoice. 
    If user only post shipment, BC doesn't create GL entries.
     
     
  • Suggested answer
    SS-24070826-0 Profile Picture
    SS-24070826-0 28 on at
    Can't generate General Ledger Entries
    Dear Guys
     
    My process:
     
    - Sales Order - generate to "Warehouse Shipment"
    - Warehouse Shipment posting automatically generated:
         a. "Posted Warehuse shipments- Archive"
         b. "Posted Sales Shipments - Archive"
     
     
     
    Thank you
     
     
  • gdrenteria Profile Picture
    gdrenteria 12,167 Most Valuable Professional on at
    Can't generate General Ledger Entries
    Hi
    Do you have any customization in this process?
    Best
    GR

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,240 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans