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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / unit cost on a job jou...
Small and medium business | Business Central, N...
Unanswered

unit cost on a job journal - not going to 6 decimal

(0) ShareShare
ReportReport
Posted on by Need-to-know 50

Hello,

We are on FIFO - when doing a job journal I need the unit cost like the quantity to go to 6 decimal places.  

I have setup the general ledger setup to be 6 decimal but that does not seem to matter - on a job journal it only lets me go to 3.

This is a manufacturing company and I need all item related transactions to be a decimal of 6 but could get away with 5.

These transaction runs into at least 3 to 4 million a month, so those tiny rounding adds up.

please can anyone tell me how to do this.

Thank you

I have the same question (0)
  • Dallefeld Profile Picture
    Dallefeld 193 User Group Leader on at
    RE: unit cost on a job journal - not going to 6 decimal

    So even though the cost on the job journal is less than six decimals, adjust cost is going to pull costs from inventory to match what was put in even regardless of the decimals that you are seeing in the job journal. You should not be overriding the costs in the job journal. Remember that in your general ledger everything is round to two decimal places and differences are posted to specific accounts in your general ledger for roundings.

    I worry that maybe us production orders might be better than jobs for your decimal issues? Have you considered this? Would like to understand your reasoning for using jobs.

  • Need-to-know Profile Picture
    Need-to-know 50 on at
    RE: unit cost on a job journal - not going to 6 decimal

    Hello Kim,

    Thank you for the reply - unfortunately they are using an outside manufacturing system that measured the length, strength, width, size, weight plus a lot traceability that is 16 char and serial numbers that are 24 char - custom made software for the steel, so could not use BC but what we are doing is taking the component used and reducing the weight of the steel using a data connector which has 6 decimal places and importing this directly into a job journal to cost the job and this is where we are getting this huge variance because it wants to round it up to 2 and if you take millions that rounding is quite a big amount. 

    Is this enough info for you to go on to?, 

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
Rishabh Kanaskar Profile Picture

Rishabh Kanaskar 4,285

#2
Sumit Singh Profile Picture

Sumit Singh 2,725

#3
Nimsara Jayathilaka. Profile Picture

Nimsara Jayathilaka. 2,526

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans