

David Wiser
Forum Replies Created
-
David Wiser
MemberJune 12, 2023 at 10:35 am in reply to: Anyone using the Multiple Posting Groups for Customers/Vendors in BC 21+?::Some additional comments. Once you turn on the feature, you turn on the functionality in the S&R Setup or the P&P Setup. Then, you also have to turn it on for the individual customer and/or vendor. On the setup pages, there is only one option under Check Multiple Posting Groups which is Alternative Groups. The alternative groups are set up under the Customer/Vendor Posting Group page. After setting up multiple posting groups, you can assign one or more posting groups as an alternative for another. The alternates are not set up by customer/vendor, but at the posting group level. Not really ideal since you may want to allow different alternate posting groups depending on the customer/vendor.
Another issue is that the Customer Trial Balance, Aged Accounts Receivable, etc. reports are all filtered based on the Customer/Vendor Posting Group assign to the customer or vendor, not the posting group for the transaction. So, if you are trying to balance transactions to the G/L when using different posting group for a customer/vendor, you may have to reconcile manually.
Interesting feature, but not thought out completely (IMO).
-
::
A couple of things at play here. When you roll standard costs and it calculates to $0.69, that is what any new inbound entries would be valued at. The Unit Cost field on the item card is designed to be the weighted average cost of the inventory you have on hand. This should also be the value on the Inventory Valuation report. The unit costs on the Inventory Valuation is a calculation of the Cost Amount divided by the quantity. So if you have layers in inventory that have different costs, the report will give an weighted average.
I am also tagging Kim Dallefeld on this who may have further insight. @kimd
-
-
David Wiser
MemberJune 1, 2023 at 10:03 am in reply to: Customize List Page to focus always on New button during open.::Carlos, are you asking if this is possible and how to do it? Not sure that this is possible, but will need a developer to chime in. @bradprendergast
-
::
Like Chris, I also do not have any blank user IDs. If the personalization was done for the role, it is captured in the “Customized Pages” page. Did you recently remove a user? If so, they may have had personalized pages. Also, I noted that all your examples had “Legacy Personalization” checked. This usually means the personalization was made in an earlier version of NAV.
-
David Wiser
MemberMay 2, 2023 at 1:53 pm in reply to: Closing inventory period – problem with Service Item::A couple of questions:
1. You said the quantities in the Item Ledger Entry are 1 and -1. Is that also true for the Remaining Inventory fields? Since this is a service item, the remaining quantities should be zero for both the receipt and the undo receipt.
2. On the item card is a flag labeled “Cost is Adjusted”. Is this checked or unchecked. For service items, this should always be checked since the item never has adjust costs run against it.
Lastly, can you run the close inventory process with the debugger turned on? Upon failure, the system should provide the actual item which is throwing the error. I have seen where the error message presented is not showing the actual item that is in question.
Dave
-
-
::
Generally, when planning for an item using the Planning or Requisition Worksheet, the system will use the default vendor on the item card when adding the purchase suggestion on the worksheet. The exception to this goes back to Amanda’s question on whether you’re using Stockkeeping Unit Cards by location. If so, you can specify the default vendor for the item for that specific location. As a result, on the planning worksheet, it there is demand for that item at the specific location, the system will first look to the SKU card for the vendor before going back to the item card for the vendor. This can really help purchasing as different locations may source items from different vendors.