WHEN 1 THEN 'New'
WHEN 2 THEN 'Used'
WHEN 3 THEN 'Leased'
END as nvarchar(50)) as c_AssetType
WHEN 1 THEN 'Active'
WHEN 2 THEN 'Deleted'
WHEN 3 THEN 'Partial Open'
WHEN 4 THEN 'Retired'
END as nvarchar(50)) as c_AssetStatus
WHEN 1 THEN 'Personal'
WHEN 2 THEN 'Personal, Listed'
WHEN 3 THEN 'Real'
WHEN 4 THEN 'Real, Listed'
WHEN 5 THEN 'Real, Conservation'
WHEN 6 THEN 'Real, Energy'
WHEN 7 THEN 'Real, Farms'
WHEN 8 THEN 'Real, Low Income Housing'
WHEN 9 THEN 'Amortizable'
END as nvarchar(50)) as c_PropertyType
WHEN 1 THEN 'Reserve'
WHEN 2 THEN 'Depreciation'
WHEN 3 THEN 'Cost'
WHEN 4 THEN 'Proceeds'
WHEN 5 THEN 'Recognized Gain/Loss'
WHEN 6 THEN 'Non Recognized Gain/Loss'
WHEN 7 THEN 'Clearing'
END as nvarchar(50)) as c_TransactionAccountType
WHEN 1 THEN 'Straight-Line Orig Life'
WHEN 2 THEN 'Straight-Line Rem Life'
WHEN 3 THEN '125% DB'
WHEN 4 THEN '150% DB'
WHEN 5 THEN '175% DB'
WHEN 6 THEN '200 DB'
WHEN 7 THEN 'SOY Digits'
WHEN 8 THEN 'Remaining Life'
WHEN 9 THEN 'Amortization'
WHEN 10 THEN 'ACRS Personal'
WHEN 11 THEN 'ACRS Real'
WHEN 12 THEN 'ACRS Real MSL'
WHEN 13 THEN 'ACRS LIH'
WHEN 14 THEN 'ACRS Foreign Real'
WHEN 15 THEN 'No Depreciation'
WHEN 16 THEN 'Declining Balance'
END as nvarchar(50)) as c_DepreciationMethod
WHEN 1 THEN 'Half-Year'
WHEN 2 THEN 'Modified Half-Year'
WHEN 3 THEN 'Mid-Month (1st)'
WHEN 4 THEN 'Mid-Month (15th)'
WHEN 5 THEN 'Mid-Quarter'
WHEN 6 THEN 'Next Month'
WHEN 7 THEN 'Full Month'
WHEN 8 THEN 'Next Year'
WHEN 9 THEN 'Full Year'
WHEN 10 THEN 'Full Year All Year'
WHEN 11 THEN 'None'
WHEN 12 THEN 'Next Period'
WHEN 13 THEN 'Full period'
End as c_AverageAgingConvention
WHEN 1 THEN 'No switch'
WHEN 2 THEN 'Straight-Line'
END as c_SwitchOver
Thanks to Victoria Yudin. https://victoriayudin.com/gp-tables/fixed-assets-tables/
I’m just making these so we don’t have to re do this over and over again.
Victoria Yudin has some very useful information on the web but, I need a practical script for SQL. Now you can have it too.
cast(case DISTTYPE when 1 THEN 'Cash'
WHEN 2 THEN 'Payable'
WHEN 3 THEN 'Discount Available'
WHEN 4 THEN 'Discount Taken'
WHEN 5 THEN 'Finance Charge'
WHEN 6 THEN 'Purchase'
WHEN 7 THEN 'Trade Disc.'
WHEN 8 THEN 'Misc. Charge'
WHEN 9 THEN 'Freight'
WHEN 10 THEN 'Taxes'
WHEN 11 THEN 'Writeoffs'
WHEN 12 THEN 'Other'
WHEN 13 THEN 'GST Disc'
WHEN 14 THEN 'PPS Amount'
WHEN 16 THEN 'Round'
WHEN 17 THEN 'Realized Gain'
WHEN 18 THEN 'Relaized Loss'
WHEN 19 THEN 'Due To'
WHEN 20 THEN 'Due From' end as nvarchar(50)) as DistributionType
Thanks to Victoria Yudin for the source data. https://victoriayudin.com/gp-tables/pm-tables/
I have spoken with several people about the simple budget form that I’m using to help keep my self on track. I’ve been asked for it over 20 times so I’m putting it online.
The top section is for Expenses that you might share with another person in your household.
The bottom section is for items that you are paying as an individual.
While the expense values in this sheet are really mine the Income has been anonymized low enough to cover the outgo.
In this example the person would only be clearing $370 a month with this income and expense amounts.’
I used the last 3 average amounts on my bills to come up with the budgeted bill amounts.
This form is used at the risk of the user. www.mylesyamada.com makes no warranties, claims and is free from any damages that any one may seek in the future. I am not a CPA and I’m not giving or selling financial advise. This is a tool that I use in my own personal life and is meant for that purpose only.
Thanks to http://www.asciitable.com/ for the chart to build this script from.
This original work of art or code is provided free of charge for the betterment of humanity as a public service. No warranties or guarantees should be assumed or implied by the posting of this code. anyone using this code is doing so at their own risk. Be a good dba/developer and test anything found on the web in a test or dev box. 🙂
When modifying this report in Visual Studio 2010 the classes will throw all types of errors.
The first error that I got was explained here earlier today Next there was an error when refreshing the PurchPurchaseOrder Data source on the AX 2012 Reporting services Report. It stated that, “Element’;PurchPurchaseOrder.Parameters.IsPurchConfirmationRequestJournal’ has already been defined. To correct this, rename on or more of the model elements so that they have a unique name. Another developer already solved this issue so here is his fix: The second error was explained here The last error that I received was this:
Error 1 An exception occurred in the query metadata execution. The exception is Function PurchTableAllVersions.initFromProformaPurchTableVersion has been incorrectly called.(S)\Classes\xInfo\add(S)\Classes\Info\add - line 94(S)\Classes\Global\error - line 3(S)\Data Dictionary\Views\PurchTableAllVersions\Methods\initFromProformaPurchTableVersion - line 15(S)\Classes\PurchPurchaseOrderDP\initProformaPurchTableAllVersions - line 9(S)\Classes\PurchPurchaseOrderDP\retrieveJournalAndVersion - line 23(S)\Classes\PurchPurchaseOrderDP\createData - line 30(S)\Classes\PurchPurchaseOrderDP\processReport - line 52(S)\Classes\SrsReportRunRdpPreProcessStrategy\execute - line 27(S)\Classes\SrsReportRunRdpPreProcessService\executeWithContract - line 82(S)\Classes\SrsReportProviderQueryBuilder\runPreviewModePreProcessedRdp - line 29(S)\Classes\SrsReportProviderQueryBuilder\initialize - line 58(S)\Jobs\. PurchPurchaseOrder.Report [Preview] 0 0
These errors are related to the fact that we can’t run some reports in Visual Studio to see results especially if there are args that come from the AX UI. You can ignore these errors. When the report is run from the form it works perfectly.
While working on the AX 2012 R2 SSRS PurchPurchaseOrder, I was getting a lot of errors on a standard report. I ran a Generate Full CIL and got these results:
Finished pass 1 at 9/10/2014 11:20:49 PM
Finished pass 2 at 9/10/2014 11:20:52 PM
Could not find SrsReportRunController.renderingCompleted in the method map. Will attempt to use X++ delegates.
Could not find SourceDocumentProcessorFacade.processedHeaderImplEventHandler in the method map. Will attempt to use X++ delegates.
Finished pass 3 at 9/10/2014 11:20:58 PM
Finished creating types at 9/10/2014 11:20:58 PM
To fix this I went to the classes and compiled them.
Right click the class.
Right click class
You can then run a Generate Full CIL without errors.