David Wiser
Forum Replies Created
-
Unfortunately, this is not really possible with BC. I have worked with clients in the pas to develop a report but was not really successful. The problem with breaking out the sales by component is trying to tie it back to the production order which produced the goods. Working with the application tables should work but it hard to keep everything typed together. This is especially true if your sales orders pulls from multiple FIFO layers. You can break out the costs if you just focus on production, but not with sales. Sorry there’s not better news.
-
Yes, what you describe is possible. Generally, you would create the BOM for one bottle. Then, the production order could be for the number of bottles/cases/pallets you want to produce. The production order will scale up the raw material quantities needed to meet the desired output.
Reach out if you want to discuss further. Also, Steve Chinsky and I are teaching a manufacturing academy class on manufacturing before Summit in October if you want to sign up for that.
-
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.
