02/09/2012 – Benefit Function

This event was fun and a great success. Many items were auctioned off and I played for about 80 minutes.

Casa Libre Invitation – You can download a copy of the flyer by clicking on the link. This is the next function I will be playing the cello on 02/09/2013. There may also be other artists there if all goes well.

The Casa Libre shelter works with youth ages 12-17. The shelter provides unaccompanied youth with clothing, food and a place where they feel comfortable to live. By attending this Art Show you will not only have a night full of fun and entertainment, you will also be helping out the Casa Libre shelter to continue in what they do. The Art Show will be composed of live music, Art for sale, a silent auction of many items, a raffle and free food as well. Please join in on the fun, tell a friend bring a friend.

Casa Libre House, Circa 1912

February 9th, 2013 5:00 pm to 8:00 pm

Casa Libre Freedom House 845 South Lake Street; Los Angeles, CA. 90057 Telephone: (213) 637-5814

Recent Posts

Great Plains – Asset TSQL Case Statements

Cast(CASE ASSETTYPE
 WHEN 1  THEN 'New'
 WHEN 2  THEN 'Used'
 WHEN 3  THEN 'Leased'
 END as nvarchar(50)) as c_AssetType

Cast(CASE ASSETSTATUS
 WHEN 1  THEN 'Active'
 WHEN 2  THEN 'Deleted'
 WHEN 3  THEN 'Partial Open'
 WHEN 4  THEN 'Retired'
 END as nvarchar(50)) as c_AssetStatus

Cast(CASE PROPTYPE
 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

Cast(CASE TRANSACCTTYPE
 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

Cast(CASE DEPRECIATIONMETHOD
 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

case AVERAGINGCONV
 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

CASE SWITCHOVER
 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.

  1. DOCTYPE Case Statement for Great Plains Comments Off on DOCTYPE Case Statement for Great Plains
  2. DISTTYPE Case Statement for Great Plains Comments Off on DISTTYPE Case Statement for Great Plains
  3. SSIS Expression Convert From IntDate to String Comments Off on SSIS Expression Convert From IntDate to String
  4. Budget Form for people who need one Comments Off on Budget Form for people who need one
  5. TSQL – Replace URL Escape Characters Comments Off on TSQL – Replace URL Escape Characters
  6. Editing AX 2012 SSRS Report – PurchPurchaseOrder Comments Off on Editing AX 2012 SSRS Report – PurchPurchaseOrder
  7. Could not find [class].[method] in the method map. Will attempt to use X++ delagates. Comments Off on Could not find [class].[method] in the method map. Will attempt to use X++ delagates.