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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested Answer

[Scenario] Posted Purchase Receipt not added dimensions, and now we need to.

(4) ShareShare
ReportReport
Posted on by 4,979
[edited]
Hi Community,
 
I have a scenario that I wished to ask.
 
We have been using NAV BC for quite a while. Recently, management decided to implement Dimensions to track finances better. So at COA we also implement Code mandatory Dimensions for relevant onces'
 
While we successfully implemented Dimensions, we notice that when there are POs that is still not yet full received and invoice, when user starts to post,
Navision will prompt that certain GL account number, ie 1506, for the Dimensions group XXXX is code mandatory and requires a value.
 
If I did a check, on the Purchase Lines there are no GL1506 on the lines, moreover, all the dimension code mandatory columns fields have been input.
 
Upon checking further, I see that the reason that Dimension was prompted was due to a purchase receipt that has been receive in the same PO was not having that dimension.
 
However, we can no longer input that dimension fields, since it has been received.
 
So the solutions I can think of is...
 
1. Do undo receipt for the Posted Purchase receipt, and then input the correct Dimensions and post it as post purchase receipt again. However, we are not sure if we can still do this as the items might have been sold.
 
2.  Remove the mandatory dimensions for this GL to let this PO pass first. however, that means when the report for the dimensions come out, the values for that Purchase Receipt will not be taken into consideration. :-(
 
Kindly advise if no. 1 is good, else what else I can do in put the Dimensions? 
 
Thank you !
I have the same question (0)
  • Suggested answer
    Holly Huffman Profile Picture
    6,534 Super User 2025 Season 2 on at
    hi there!
     
    i think both your solutions have merit! 
    since your received PO lines have possibly been sold -
     
    you may want to try creating a General Journal to correct the dimension: 
    - general journal > create a journal entry to reverse the original receipt with no dimension 
    - create another journal entry with the correct dimension 
     
    ---- ensuring the net effect of the entries is zero - meaning they cancelled each other out except for your dimension correction 
     
    - post the journal entries
     
     
     
     
  • Suggested answer
    Khushbu Rajvi. Profile Picture
    20,443 Super User 2025 Season 2 on at
  • Suggested answer
    Nitin Verma Profile Picture
    21,708 Moderator on at
    Yes you can go with Option 1, but before that you can follow below steps:
     
    Temporarily Remove Mandatory Dimension Requirement
    1. Open the G/L Account Card for 1506.
    2. In the Default Dimensions (accessible via Navigate > Dimensions), change the Dimension’s Value Posting from "Code Mandatory" to "No Code" or "Same Code" temporarily.
    3. Post the PO (receipt or invoice).
    4. Restore the "Code Mandatory" setting afterward.
  • joshtechsolutions Profile Picture
    4,979 on at
     
    Thank you for your reply.
     
    My apologies, I forgot to add. If I remove the mandatory dimensions for this GL to let this PO pass first. however, that means when the report for the dimensions come out, the values for that Purchase Receipt will not be taken into consideration. :-(
     
    Pls let me know if I have anyway to add back the missing dimension.

    Thank you !
  • Suggested answer
    Valentin Castravet Profile Picture
    31,481 Super User 2025 Season 2 on at

    Can you clarify the following:

     
    1. Are these old purchase orders that were created before you made dimensions mandatory? Or they're new ones.
    2. What is GL account 1506? Is this your inventory GL account?
    3. Do you have expected cost posting turned on?
     

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

Responsible AI policies

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

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,362

#2
YUN ZHU Profile Picture

YUN ZHU 867 Super User 2025 Season 2

#3
Sumit Singh Profile Picture

Sumit Singh 607

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans