Inventory, Orders Management, Warehouse Operations
- 1,027 Topics
- 3,992 Replies
Report visible expression highlight color
In a report I want to highlight/ change the background color if the value is greater than 1. I understand i need to put two fields on top of one another. One with the default state and one with the changed state. my questions are as follows:=[POLine.BaseOpenQty]=[POLine.BaseOpenQty] Do I use visible expressions for each field? Can you help me write the expression?I am leaning towards an IIF, but that is as far as i got.
Hold AP Bill until three match complete.
Our specific scenario is:1. We place a Purchase Order and transmit it to our partner via EDI2. Our partner ships the product.3. Partner sends us an Invoice via EDI.4. The Invoice is entered as an AP Bill against the PO.5. We receive the inventory.We don't want to pay the bill in step 4 until we get the inventory in step 5. We also don't want to prevent the bill from being entered because that basically eliminates the benefits of EDI. (nor do we want to put business logic in the EDI layer to not import the AP Bill) So, is there a way to configure the system such that the only items that can be paid on an AP Bill linked to a PO are those items that have been matched to a PO Receipt?
USPS Stamps.com Carrier plugin: Shipping on a customer carrier account number is deducting from my stamps.com balance.
Hi We have the USPS Stamps.com Carrier CS207700 plugin (PX.StampsCarrier.StampsCarrier) set up in Acumatica with our stamp.com account number and user information. Additionally, we have a customer set up using their stamps.com account number. We are facing the issue that stamps.com is charging our account balance and not deducting or connecting with the customer account. We have the ship via set to the corresponding method on the Shipment document and have checked off the settings to Use Customer Account. I have looked over the trace and profiler to see if anything suggests the customer account number or our account number being used. This information does not show. Any support or direction will be helpful. Thanks, Schneur
Mutli Currency on Purchase Order not flowing through to Purchase Receipt
Hi All,Firstly the base Currency for the Tenant is AUD. Scenario:-I enter a Purchase Order in a USD Currency. USD $1.3888 to AUD $0.7200. I then click “Enter PO Receipt”. The Currency from the PO does not reflect in the Receipt. Therefore on receipting the Average Cost of the Item does not update to the new cost.Any help understanding this appreciated.Regards,Laura
Scales / Device Hub and Warehouse Managment
Device Hub is configured with local usb scale and weight is displayed, Acumatica is seeing the scale on he Scale screenItem is set to manual pack with a weight.When confirming a package with the item in WMS / Pack the system is using the weight of the product.How can you configure to have the package weight pulled from the scale and not use the item weight
Removing Address and Contacts
We have dropship customers that require us to remove (overwrite with "X") the customer's contact (ARContact, SOContact) and address (ARAddress, SOAddress) information every few months. The address and contact are overdriven on sales orders and invoices. Acumatica's privacy tools seem to go too far, restricting the customer's account as well.Does anyone have a solution for this?
How to Process Requisition Requests with Non-existing items
We are new to acumatica and trying to use the Purchase Request / Requisition process. In our legacy system the users will make purchase request for known and unknown items. In acumatica we are able to make the requests for unknown items however, when our purchasing personal try to create the requisition from the request we get errors as the ItemID does not exist. Is there a workflow where you can take the request item information and create a new item from it? Or does anyone have any ideas on how you could allow requestors to make a request for non-existing items or vendors?
How to change location on SPLIT line in a shipment
Hello everyone,I have a big order that need to pick item from different location. In shipment it shows a total quantity with SPLIT location line. In pick list it shows every locations that worker need to pick item. The problem is for some reason the location B300-09B is empty. Worker picked item from another location. How do I change the location for this case?
Landed Cost Variance
Hello,I have a small issue with landed cost as some of the landed cost goes into the Landed Cost Variance Account and it does not show in the Inventory Valuation report and the Average Cost in the Stock Items.Does anyone know the workflow to correct this issue?The final bill of the landed cost cost is entered after we received our goods and we start selling them right away.Landed Cost Variance AccountThe expense account to be used for this stock item to record the landed cost difference that occurred if landed costs are allocated to an item that has been sold. Thanks,Nelson
Double qty available for Purchase Receipt
We have a new implementation of Acumatica and are finding our way around. We have noticed that it is possible to receipt a higher qty of items than was on the original PO, it seems like at least double or more. How can we prevent or limit this? On the vendor the max% is set to 100. Surely it should not allow more than 100%?
Define Stock Part Customer Alternate ID for Parent Customers To Use for Child Customers
We use Parent/Child Account relationships extensively for our Customer base. We also use a ton of Customer part numbers as Alternate IDs for our stock items. This is becoming very difficult to manage when we have some parents with 100 child companies. Is there a way to set an alternate ID of a part number for a Parent account, and have it be used for its child accounts? We can’t use Global in this scenario because we need to be able to use the alternate IDs on customer facing paperwork as well.
Changing the lot class of preexisting item numbers
We currently are assigning lot numbers at the kit creation level, but would like to switch to assigning lot numbers at invoicing instead. Can we simply change the lot class of each item in our system to have the lot be assigned when used instead of when received?
Automatic Calculation of Selling Prices
I would like to find out what customization is required that Selling prices are automatically calculated based on the latest average cost but with a known and required GP% (not just a markup). Also, the latest average cost should be able to take into account landed costs. The landed costs in many cases in presented scenario are levies that should be automatically estimated until such time that the landed costs invoices arrive much later. Levies should be calculated and auto applied to inventory from the normal suppliers invoice. If anyone know perhaps the extent of customization that is required to achieve this requirement it will be highly appreciated.
Question about Landed Cost adjustment
If we create a sales order with a cost of 11.00 and subsequently we create a landed cost adjustment that adjusts the cost to 11.50 is any sales order with that updated with the new cost? What if we’ve created a shipment for the item. Will the system adjust the cost if a landed cost adjustment is made after the shipment. I would imagine that once it’s invoiced the cost adjustment will not affect it. So, my question is at what point will a landed cost adjustment affect the cost of the item as related to a sale of that item.Thanks
Projection of inventory
I was wondering how well our Acumatica distribution takes care of planning purchase orders and inventory projection (calculation). Attached is a possible scenario in Excel format.. I have also submitted this to AUGForums.com (https://www.augforums.com/forums/acumatica-distribution-modules/replenishment-demand-calculation-and-order-types/#post-6068 )., I didn't check D250 but I did search the help.acumatica.com and didn't find any answer. The projection of SOs, shipments, POs, receipts and inventory level for a particular item in to the next 4 weeks is a basic necessity for warehouse people. purchasing people and manufacturing people. It should be available in the inventory module and the MRP module. When inventory falls below the ROP for instance in week 2, a red flag should be raised. A bar chart would be nice. Thanks for your help. Toon Six (ToonSix@intercs.com) .
Carrier Service returned an error. 1000: Authentication Failed
Using the Fedex plugin on v2022 R1. We get this error when clicking Confirm Shipment. The Shop for Rates button works fine. This is connecting to the Production Fedex account.When using the Test Fedex account, we don't get the error. It seems there's a setting on the Production account that we're missing?
Already have an account? Login
Social LoginLogin with your Acumatica account
Login to the community
Social LoginLogin with your Acumatica account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.