Browse By Tags

Hello, I want to use the report "Bank Account in Ledgers Report" for petty cash accounts as well. While printing the report under parameter section, i can see the petty cash accounts but when i click on bank selection it says record does not exists…

I'm looking for ideas as to the best way to consume packaging in work orders. We sell products in various packaging....totes, drums, pails, etc. Currently the packaging is relieved from inventory at time of sales invoicing.....packaging codes are…

Trying to figure out how to invoice clients who have flat rate task and hourly task on one bill Example file application- flat $1400 report application as filed $18/ hrly can I invoice a flat rate task and an hourly task? Can I invoice a flat rate…

Hi, Please I need serious help, in solving this issue. I created a new field in the management tab called category that is jumps to the product category table. So I am trying to make the selection of itmref field in the line tab in order filter…

Dear Mates. I am working on X3PU9 with a fully customized screen, however, a pen sign appear in the right list and blocking me to do any action on the screen. The message showing "You only have viewing rights...". I am accessing with 'ADMIN' Id, which…

Hi, Please I was trying to add a new field to a table when trying to save it pops up this error..please help me Thank you .

Hello Everyone, Is it possible to add Dimensions in account/nominal ?? I am able to add dimension under account 31100 (on screen). However, when I click on SAVE button, it throw error " Error in pyramid 31100 " and records didn't save in database…

Hi, I am trying to get a value display on a field on the PO line screen. This is the concept: field description data type [M:POH2]GROPRI entered md8 (internal type: decimal) [M:POH2]DISCRGVAL entered md8 (internal type…

I am attempting to create a simple query showing invoices that have been posted for the day. I'm using SINVOICE, SINVOICEV, SINVOICED, and GACCENTRY all joined via NUM_0, plus a join from SINVOICE.GTE_0 to GACCENTRY.TYP_0. When I attempt to save/validate…

I need a report to show me any AR that was billed prior to 7-1-2017, but NOT paid as of 12/31/2018. Is there a report in TS that will give me this info? Or a combo of a couple reports that I can then put the info together in Excel? I use TS Premium …

I need to add our clients number (Nickname 2) to the WIP reports, anyone have experience with this? I have had no luck creating from scratch and was hoping to use our current WIP report and add the field (but the option doesn't show)

Hi to all brothers & sisters I am currently working on X3PU9 navigation function (Jump to) in table (NBLIG) from customized screen to Journal Entry. I did realized the GAS object is using HAE3 as index key. However, when i apply the code, it not able…

I need to make a minor change to the L-PB Detail with Stored contract invoice format. The CNAME in TS Billing Field Names is giving our group name instead of the Company name. We have 5 companies and I need it to give the correct Company name based on…

Hi I am hoping you can help, I have created a custom Class and Representation, that lists some information about our products, and an Image. Below is a screenshot of the end result; Please can you advise if it is possible to increase the thumbnail…

Hello I have design the master detail for testing purpose. I am not able to save the data in the grid (details table) but master table data gets saved Can i get some help?

Hello Guru's, One of our customers noted that Sales Delivery Module doesn't have the standard capability of filtering the Sales Order Selection like the function currently available in Purchase Invoice where the module has a line menu for Purchase Order…

How can the three buttons in the top button row V12 UI be customized. For example, in the Sales Order screen, buttons available on top (out of the box) are Allocation, Preparation and Delivery. We don't do any of that and would like those to be Invoice…

Has anybody tried printing a crystal report via web services by creating a subprogram? If so, could you please send some examples so I can take a look at what was done to get this accomplished? If not, anybody got any ideas on the best approach for this…

Hi I created a custom field in table BPCustomer table. Enabled the item in SPEBPC script.When I enter text it does get stored in TEXCLOB table.(The save button also doesn't get enabled) When I enter text in this field I want to store it.How can…

Hi, I wondered if I could tap in to sage city for some advice, as I am frustrated with support.na.sage The whole reason I am here, is that when I search the support site, I get to a issue, on the topic I want to learn about, and the article has a an…

Can anyone recommend a Sage Specialist for writing reports in the Financial Reporter in Canada? I need help and it can't be someone who is just learning to write these things, its a little complex.

Hello, Please how can i design a report using crystal report to include the dimensions picked on the product lines.. Thanks

I would like to make a bundle in node.js, for Webservice consumption and add to X3.

Hi, How can I create two or more instances in V7 Style code ( Leave request representation) ? In this specific case I want to create as many entrys in the table as contracts registered for the Employee. I tried with a For Cycle in "AINSERT_AFTER…

Hi, I would like to know if there is a way to increase the number of buttons showing on the screen header. As example: On Suppliers, I added 2 new buttons, Test 1 and Test 2, but on the header there are only 3 buttons ----------------------…