Method Community

Hi, In a Grid, I use SQL override for a column, and I enable "subtotals" for this column. However, this "subtotals" is display with decimal point. Even I tried to use CAST(my_column AS Int), it is still the same. Is there any way that I can change the display format for this auto-calculated value? Thanks. And, for this same ...

Hi Method, For SQL override, does Method system support Now() and DateDiff() function? I'm trying them but the grid always show "Error Generating Grid". Thanks. -- Alex

Hi Method, I encountered an issue that Method can not get correct shared result correctly. I have some actions in a button, here is the debug output Debug Tracing Why am I getting this popup? You, or another user has turned on debug tracing, which gives you a list of all actions, and their values, that are run when a button is ...

Hi, I have a question regarding how Method calculate subtotal/total in an Invoice and Sales Order. If I have InvoiceLine or SalesOrderLine in an Invoice/SO, after "Save all sections", I can always get correct subtotal/total from table and display it on the order screen. However, if I delete all items from an Invoice or a Salesorder, ...

Hi Justin, Thanks. That really helps a lot. -- Alex

Hi Justin, Thanks. There is no delete button for this new created field (in my case, "test" field). -- Alex

Hi, I have a question about LinkToPurchaseOrder field in BillLineItem Table. This field actually is RecordID to purchaseorderline table (according to the tooltip of that field.) However, if I want to add some linked field via this "LinkToPurchaseOrder", I can not see all fields, just some linked RecordID. However, if I add my own field ...

Hi, While customizing Bill screen, default logic will check PurchaseOrderLine:receivedQuantity and PurchaseOrderLine:Quantity then decide the rest quantity for a new BillLineItem. The question is, is PurchaseOrderLine:receivedQuantity updated by QB desktop after sych? If I want to leverage this receivedQuantity field in the same way before ...

Hi, Thanks. I could split it to some tabs, just wonder if it is root cause or some settings issue that I don't want to see while deliver this to my clients. --- Alex

Hi, I met an issue while layout my tab link under a tab. here is the scenario: 1. I have a Tab, which contains 36 tab links. 2. The first time I switch to that Tab, then click any of its tab link, the system can show correct screen. 3. But, for some of the tab links, once I enter their assigned screen, if I click on any tab link, the system ...