David Wiser
Forum Replies Created
-
You could set up a work center for the expense and add that to the routing. Change the Gen. Prod. Posting Group to one tied to the GL account you want to post to. Then you can post output for that work center to bring in the cost. If there is a specific cost for a routing for that work center, you can enter the specific cost on the routing line (after clicking on the “Specific Unit Cost” flag on the work center.
-
What you’re asking is possible depending on your version. I believe v14 has this functionality. If you navigate to “Custom Report Layouts” you will find that you can create and name multiple formats for the same report (Posted Sales Invoices for example). There are two other pages you will need to be aware of. The first is “Report Selection – xxx” where xxx is the functional area. If you open the Report Selection – Sales page, use the Usage field to identify which report to use when you perform that use. The next place to go is “Report Layout Selection”. This page allows you to select which format of any particular report to use as the default format. You can select one of the built-in formats or one of the custom formats you created. This is used as the default. You can also override this on a customer level by opening a customer card and selecting Document Layouts from the ribbon. This will allow you to assign a specific layout of the document for that individual customer. Try this out and let us know if you have further questions.
-
One of my clients also had the issue with needing to set up the blank location in the Inventory Posting Setup. It appears that even though you are using direct transfer, the system is still going through the normal transfer order process where it moves the product from the Transfer-From location to the Intransit Location and then to the Transfer-To location. Since the intransit location is blank for direct transfers, the system errors unless you have the blank location set in the posting setup. Bad design. The direct transfer feature should bypass that part of the code and transfer the inventory directly from the “from” location to the “to” location.
-
This “feature” hearkens back to how banks process the file. When the ACH process began, payment files were required to be generated with rows in increments of 10 lines. Most formats have two header lines and two footer lines. So, if there is one detail line, that is a total of five lines so the program adds five lines of 9’s to get to the ten line increment. If there were six detail lines, then the file would be ten lines and no “9” lines would be needed.
As far as I know, you will need a developer to remove the feature, but most banks understand this (and may even require it). Check with your bank to see if the lines must be removed.
-
You can open the ledger entry table for the entry that you are concerned about. Let’s say the general ledger. Navigate to the General Ledger Entry table and find the entry in question. Open the Page Inspection pane. You can do this by clicking Cntl+Alt+F1 or by clicking on the question mark, then selecting Help & Support, then click Inspect Pages and Data. This pane will show all the fields in the table. Use the magnifying glass and search for SystemCreatedBy. This will give you the user ID of the person that posted that entry. This works for other ledger entry tables as well.
-
Are you looking for more than just posting credits on customer accounts? You can do that with BC/NAV by posting credit memos to the customer and then reimbursing them using the “Refund” entry type. If you are looking for calculating rebates or commission in order to post those credits, than you are most likely needing to use a add-on solution. Search AppSource and you’ll find several.
-
After testing, I found that if you reorder the payment journal by description (which holds the vendor number) and then add sequential document numbers, the checks will print in alpha order. The journal appears to first look at sorting by document number and then line number. The system will replace the manually added document number with the check number after printing (which is line number order), but the print job should be in alpha order.
Don’t use the “Renumber Document Numbers” function as that numbers then in line number order. You need to manually enter document numbers in the print order. Painful if there are lots of checks, but it works.
-
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
