Skip to main content

Notifications

Announcements

No record found.

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

Can't generate General Ledger Entries

(1) ShareShare
ReportReport
Posted on by 32
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
 
  • SS-24070826-0 Profile Picture
    SS-24070826-0 32 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 32 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 32 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,929 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 32 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 25,025 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,440 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 32 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,929 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

Congratulations 2024 Spotlight Honorees!

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December!

Congratulations to our December super stars! 🥳

Get Started Blogging in the Community

Hosted or syndicated blogging is available! ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,379 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans