Get inspired and gain all the knowledge you need
Timesheet REST API update
I am using REST API to insert bunch of timesheets under a batch, this process is fine but later on I am not able to search through the batch in order to find a specific employee timesheet. I want to find a particular timesheet, remove it or update it and put it back using the API. Is there a way of doing this instead of deleting the whole batch and recreating it again via API?
How to configure the VAT tax settings so that we can generate a tax report with whole sales amount and cash discount displayed separately?
Hi guys,Consider this case below.If the credit terms for customers is “3% discount in 10 days, net in 30 days”, and we made a sale to a customer of $100, with a VAT rate of 10%. The customer paid within 10 days, and I’m trying to generate a tax report looks like this:Total sales: $100Cash discount: $3 (-$3 is also ok)Total taxable amount: $97Total tax amount: $9.7But according to what I have tested on Acumatica, it seems like the above couldn’t be achieved. I tried to use the cash discount feature, and the outcome looks like this:Total sales: $100Total taxable amount: $100Total tax amount: $10The total tax amount here isn’t even correct (should be $9.7).I also thought of recording the cash discount in a separate line in the invoice, but we wouldn’t know whether the customer takes the cash discount or not while recording the invoice. And once the invoice is released, I assume there’s no other way to add a line for cash discount.So any better ideas on this case? Thanks in advance.
How to account for third party Equipment (Accrual)
Whe you have rental machine that you collect time card for in the system. Upon releasing this time card you get an expense that will update my budget line meaning that I will clear my accrued liability with the supplier Invoice. The reconciliation seems cumbersome due to the number of PM transactions created by the Equipment time cards. Is there a work around to this or anyone with a good idea on report?. Project Transaction - Time card Time Card.GL Transaction. Receiving Invoice at Month end reconciliation required.- Cheking the project transaction and referencing to time cards. If the balance of the Time cards and bill are not the same adjust via the Time card correct Function.
Create a Custom Table Using Excel Data
Hi, I need to create a custom table and data need to inserted from excel. Excel sheet need to get from drive location and excel data need to be uploaded into my custom table. Excel is replaced daily into the drive.So, Data import activity need to be scheduled. How to archive above both scenarios or give the workaround for archiving it.
Acumatica Global Search Improvements
Hi Community, We are planning to rework our Acumatica Global Search (or Universal search) and now we are collecting requirements for this feature. The most popular ideas like categories and including attributes have been already included, but still, we would like to ask for your opinion about any ideas and problems related to global search, feel free to write it here.
Request for SO Order View - Availability
Hello,I am trying to get an unbound field to populate with availability on the sales order line based on joining to the INSITESTATUS table. This works on pxdefault- however, it begins to break down when I’m updating allocations on the sales order and am pending a commit. I have a sense that there is a view that is being manipulated as the order is being input keeping things in sync before they are committed to the database and I just can’t seem to find anything written about it. Does anyone know what view is being updated to reflect the item availability information at the bottom of the grid? The end goal is to trigger an approval rule based on the availability. If there is any other way of doing this, I’m open to suggestions. Thanks in advance!
The formatting of for each loop in notification template
I am using a GI as data source, and trigger business event to email sales that some shipline is not shipped in full. I will list all shortage ship lines in the email body. It is working fine with the below method. However, the sales are complaining it is not looked nice, Like below Can I make each field display in fixed length, just like what is showed in Report designer?
How to add supplier bank account no in same format based on the supplier master--> Payment instruction
Hi, I’ve added supplier bank details in the supplier master GI, but bank account number is not displaying in the same format as per the supplier master payment instruction. so how we can solve this.I would really appreciate, if someone can help me on this.
Approval Maps using Employees by Filter
Hi, I have a client that requires two people to approve the PO. I have set the Approver to “Employees by Filter” in the used Rule Action however once the first user Approves the PO is approving without the second approval.The settings i have used are below. What am i missing? Any help appreciated. Laura
My company home page is not showing up as the default home page for all users
When my company users login they get a home page that is not my company’s. The company’s home page has been setup in site settings and in all users profiles. However, it does not show up when login in. Instead a “generic” acumatica page shows up. The user has to click on the company logo (Upper left corner) to launch my company’s page. Users are finding this very invasive! We need help asap!
GI needed to display days in-stock
I’m trying to determine the best way to create a GI that displays the number of days a stock item has been “in-stock”. Does anyone have any suggestions? I thought maybe using the INItemSiteHistDay table would be the way to go but I’m just not sure where to go from there. We’re also using the Average inventory valuation model which does us no favors when it comes to item history. Any suggestions are appreciated.
Does Acumatica has any method to identify how a record has been created?
Hello All, Does Acumatica have any method to identify how a record has been created or is being created? By this I mean whether a record is created by user through UI, an Import Scenario, an API call … or we have to come up with creative solutions? I know in events we have e.External that identifies if UI has made the call or some internal processes but I have not come across entry source identifying methods? Any help is appreciated. @Yuriy Zaletskyy
Visible Expression works for field, but not section
I’m trying to build two ‘alternate’ sections:Limited space that only shows “Continued” (if the details extend beyond one page) Visible expr: =([PageIndex]<[PageCount]-1) Larger space that shows the full subtotals (intentionally the second-to-last page for terms & conditions at the end) =([PageIndex]=[PageCount]-1) If I apply the visible expressions to the group, it does not appear on any page.If I apply the visible expressions to the individual fields, it appears as-anticipated (though this defeats the purpose). Additional information:The ProcessOrder is Always in both scenarios The PageIndex and PageCount are definitely calculating in both scenarios Both are GroupFooters that are setup to PrintOnEveryPage (with the above exceptions, if I can get them to work)Any ideas? Suggestions?
ARDunningLetter.Deadline Field on Stock Dunning Letter Form AR661000?
Doing some editing work on stock Dunning Letter Form, but can’t seem to figure out how to manipulate the ARDunningLetter.Deadline field that is showing up on my Dunning Letter. Looks like it is adding 3 Days to ARDunningLetter.DunningLetterDate, but not sure where that additional 3 day setting would be coming from?
Ways to use Buildings
HI everyone,I have a customer implementing Acumatica and they have a need to be able to ship from various warehouses on the same order. They need to be able to keep track of inventory though. If we used the buildings in Acumatica, what is the best way to process this?The Building Name would be Main, then each warehouse would be A, B, C?Does anyone have thoughts or ways to work around not being able to combine warehouses on shipments?
When is the Location header returned via REST?
We have some heavy customizations around Sales Orders and we also have Avalara integration. When the Sales Order is saved, it can take a few seconds to save the order. When I add an order via the Rest API, I don’t receive back a Location header like I would when I call a Release action, for example.My question is: Is there something I can do to make Acumatica return a Location header when saving (PUTting) a Sales Order via the Rest API?
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.