Solved

I am performing testing on a client’s BOMs whereby materials and labor are both backflushed. The BOMs are quite simple in nature with one or two work centers. At this time we have a zero rate applied to the work center since the client has not determined the appropriate value. When production is completed and the move step is initiated, I see the materials go into WIP at the proper cost. The labor cost does not generate entry since the work center rate is 0. When I check the move out of WIP and into inventory, there is an unknown component to the entry whereby COGs and Inventory are impacted but there is not reflected in the cost of the item, nor should it be. I cannot figure out what is driving this entry.  See screenshots for example. Any idea why the highlighted portion of the entry in the last screenshot is happening?  Client uses Average Cost valuation method for inventory. I tried the Cost Roll process to see if this would fix the issue but it has not.   

HiHow can we reclaim DB space/storage after files has been moved External File Storage (SM202540). The UploadfileRivison table Data column does not get reduced if one switch from DB storage to external storage.

hi, i have the following error, between the balance and amount, it differs by one decimal place. i don't know how to do the acumatic rounding.

Hello, I have added a small customization to the Vendor Status field such that it includes a new available option for selection. This was done through the Customization Project via the ‘Fields’ section of the ‘Vendors’ [AP303000] screen, where a new Combo-box value of ‘Z’ and description of ‘Pending Approval’ (see below screenshot) were added.  The respective value of ‘Pending Approval’ is available on the ‘Vendors’ [AP303000] screen, however when running the Generic Inquiry which shows the list of Vendors, there is a slight issue, whereby the Status is being shown as blank. I have some workarounds to this such as by using a Switch function to manually show the status description, although this is not “clean” as it could break in case of upgrades and it would be considered as sort of “hard-coding”, thus is not good practice.  Does anyone know whether there is perhaps some missing configuration that I need to do to make the value description show for the new Combo-box values? Thanks in

Hello, Is is possible to change the default qty from 0 to 1 while entering line items during quote or sales order entry.  This will speed up the process due to most line entry is only quantity of 1.Thanks

Hi everyone, I want to add a 8% surcharge to the invoice. I tried to apply a -8% discount. It’s working but the problem is this surcharge will not apply to every customer. I want to know anyway to apply a surcharge by percentage ? like non-stock item or others.  

We use the drag and drop file attachemnts to add the customer PO to the SO.In some instances it shows a file in the SO but the file box is empty.What could cause this?ThanksJohn 

I have enabled other fields which were showing under Customization Screen of Process Orders but now  I want to add Ship to Country in it? How can I do it?  Thank youJennifer

Hello,I have added a dialog to Bills and Adjustments Screen to be able to route the documents to an assignee. See below snip: I have made the “Assignee” Required. As you can see the DAC is set to force the user to enter the assignee. Here is the DAC:#region Ownerpublic abstract class owner : PX.Data.BQL.BqlInt.Field<owner> { }[Owner(PersistingCheck = PXPersistingCheck.Null, DisplayName = "Assignee", Required = true, ValidateValue = true)]public virtual Int32? Owner { get; set; }#endregion What I would like to happen is to keep this dialog open if “Assignee” is null or invalid and user clicks OK but dialog gets closed. I tried to force this by field selecting/verifying but I didn’t have any luck. How can I manage this? Is the anyway to remove the close button (X) from top of the dialog and disable the ESC key on it?

After upgrading to 2021R1, the Bank Deposit screen has become unusable. We have a not-so-large ARRegister table (few million rows). It takes about 8-10 minutes after clicking “Add Payment”. Looking through the built SQL query, Acumatica is using a STRAIGHT_JOIN on the ARRegister and the ARPayment. After capturing the query and using an INNER JOIN the results are immediate. I understand the difference between the two and using STRAIGHT_JOIN is rarely used. Has anyone ran into this issue with a fairly large db?FYI - I did un-publish customizations and I also created a ticket and reproduced the issue with support. Any other ways to create bank deposits other than import scenarios since that will just make the problem worst.

We would like to hide the AUTHORIZE button in the dialog for Create Payment on Sales Order Entry.  The button should be disabled/hidden if Payment Method ID = “CCARD”  Is this something that is possible to do? I have the code to check the payment method but I’m not sure how or even if it’s possible to hide the AUTHORIZE button when the field is updated. Thanks for any advice even if it’s just that it’s not possible to do what we want. Phil 

Hello everyone  I need your help :(( I can’t find a way to add the reference Id to my parameters in GL63CG01We want to be able to filter with the reference Id (Customer/Vendor) in addition to the Account. I added to the list of parameters but it won’t show on the screen when editing the report.  I’ve copied the same setting as the AccountCD but it’s not working :’( Any ideas ?  Thnxxxxxxxxx;  

In the Customers inquiry screen, some newly created customers are not being displayed. But if you navigate to an existing customer and search in the customer ID, the said customer appears. Is there any reasoning behind this?Thank you.

Hi, We need to update the Item Cost base on the FIFO cost method. Ex. Item A - 20 Qty with 10$ After add the Laded Cost Value for particular Item Cost, it would be 12$. Have there any possibility to update the Item cost manually? Since user already has completed the landed cost process without adding additional 2$.Now we need to update that additional 2$ to Item. RegardsNethupul  

We have hundreds of items that require Expiration Dates annually. When an Item gets close to its Expiration Date we must have the product Re-Tested. Is there a way to track Expiration Dates without enforcing Lot/Serial Tracking on items? 

I have created an import scenario for orders, but the international orders will not import.  How / what code do I need to use to allow the international zips to load (alpha numeric) and then to have Hong Kong default to 00000 (they don’t have a zip code) .This is what we are using now:  =IIf(( Len([bill-postal-code])=4), ('0'+[bill-postal-code]),(Substring([bill-postal-code],0,5)))

Looking for info on how I can create a printed form for AP bills. Ultimately, we would like forms for all bill types but looking for immediate need for a Debit Adjustment printed for so we can send to a Vendor for a Debit Request (Credit Note to the Vendor). Has anyone had any success in creating these? I am a bit surprised these are not out of the box. Thanks all!

Hi, I am receiving error The financial period cannot be specified because the branch has not been specified in the Branch boxfor my  PUT request {  "DueDate": {    "value": "05/25/2021"  },  "VendorRef": {    "value": "byIvan"  },  "Description": {    "value": "BatchID \"21\""  },  "Vendor": {    "value": "V00001342"  },  "CurrencyID": {    "value": "USD - US Dollar"  },  "Date": {    "value": "04/25/2021"  },  "Currency": {    "value": "USD"  },  "PostPeriod": {    "value": "03-2022"  },  "Details": [    {      "InventoryID": {        "value": "LA3434OR"      },      "Project": {        "value": "X"      },      "Description": {        "value": " 6ft"      },      "Branch": {        "value": "GBA"      },      "UOM": {        "value": "HOUR"      },      "Amount": {        "value": "51.04"      },      "ExtendedCost": {        "value": 12.76      },      "Qty": {        "value": 4.0      },      "rowNumber": {        "value": "1"      }    }  ]}Previously when I faced with it, out cli

Hi guys,we need our backoffice employees to clock their time card for internal projects such as Administration, HR, Finance. Currently the Approval Status of the employees’ time card is “Not Required”. Where should I set up the approver? Is it in “Projects → Tasks → Approvers”?By the way, could someone please tell me if there’s a course about time card that covers most of knowledge needed to use “Time and expenses” module? That way I can get the whole picture instead of asking one question at a time here in the community. Many thanks!

We would like to change a Unit of Measure UOM of an existing stock item from EA to FT (Foot).  We want to learn the proper procedure to do this.  I trust there is a simple process for this.  Please advise.

We are a general contractor with two office locations.  Each location has its own “Branch” in Acumatica.  This works great. We are about to start a new “Division” in one of our locations.  I’ll need the ability to create financials for the new division.  Should this be a third “Branch” or should I start using sub accounts? 

Hi all,I want to add a new field to the SO that the value is from the customer’s buying group. The buying group is under the Attributes. I tried to use PXDefault to search the attribute’s value. But I have a problem is I need to use fixed attribute ID. The value is not linked with the buying group value. I need to save the value to the database at that moment. Because the buying group value may changed later. Does any one knows how to do it ? Thanks.     

I am receiving an error when trying to enter an AP Bill.The Purchase Order has one line item, for a quantity of 10 pieces. All 10 pieces have been received and a receipt for the 10 has been created and released.Now when I get the invoice a few days later from the vendor, I go to the Purchase Order # mentioned on the invoice, however, when I click the “Enter AP Bill” from the actions drop down, I receive the following error: 

I want to default 4 checkboxes (Activate Project, Activate Tasks, Copy Notes to Project, Copy Files to Project) to “checked” in the Convert to Project dialog/popup on the Project Quotes page. I’ve added “[PXUnboundDefault(true)]” to the Attributes for each of those 4 items, but it only works for the two “Activate” items; the two “Copy” items aren’t affected. Any ideas how to default the “Copy” checkboxes to true? Bonus points if you can tell me how to automatically click to OK button to submit the dialog. Thanks in advance!